USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[ChatLogSelectByLogId]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.ChatLogSelectByLogId
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 09/03/08
-- Description:	ChatLog Table Select Count By LogId
-- =============================================
CREATE PROCEDURE ChatLogSelectByLogId

            @LogId int
	
AS

BEGIN

	SELECT * FROM ChatLog
	WHERE LogId = @LogId
	ORDER BY DateTime

END
GO


